SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_GetEmployerByAccount]
    (
      @JOL_Employer_Account VARCHAR(50)
    )
AS 
    SELECT  JOL_Employer_No,
            JOL_Employer_Account,
            JOL_Employer_Password,
            JOL_Employer_Name,
            JOL_Employer_Industry,
            JOL_Employer_Type,
            JOL_Employer_Province,
            JOL_Employer_City,
            JOL_Employer_Address,
            JOL_Employer_ZipCode,
            JOL_Employer_HomePage,
            JOL_Employer_Introduction,
            JOL_Employer_Linkman,
            JOL_Employer_Mobile,
            JOL_Employer_Email,
            JOL_Employer_Phone,
            JOL_Employer_Fax,
            JOL_Employer_AddTime,
            JOL_Employer_UpdateTime,
            JOL_Employer_VerifyStatus,
            JOL_Employer_Credentials,
            JOL_Employer_IsSchoolCorperate,
            JOL_Employer_IsContactVisible,
            JOL_Employer_IsVIP,
            JOL_Employer_CredentialsFileLink,
            JOL_Employer_AddUser,
            JOL_Employer_UpdateUser,
            JOL_Employer_VerifyUser,
            JOL_Employer_VerifyTime
    FROM    dbo.JOL_Employer
    WHERE   JOL_Employer_Account = @JOL_Employer_Account
GO
